// movie索引里面有数组字段, sql模块不支持, 会报错 Arrays (returned by [genres]) are not supported
POST /_sql
{
  "query": "SELECT * FROM movie WHERE release_dates.date < '2000-01-01'"
}

// 这里得手动指定select
POST /_sql
{
  "query": "SELECT id, title, overview FROM movie WHERE release_dates.date < '2000-01-01'"
}

// 可以指定返回结果格式为txt
POST /_sql?format=txt
{
  "query": "SELECT id, title, overview FROM movie WHERE release_dates.date < '2000-01-01'"
}

// 支持的格式包括csv, json, tsv, txt, yaml, cbor, smile
// https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-rest-format.html

// 翻译接口
POST /_sql/translate
{
  "query": "SELECT * FROM movie WHERE release_dates.date < '2000-01-01' order by release_dates.date desc",
  "fetch_size": 10
}